﻿CREATE TABLE [dbo].[Booking]
(
	[bookingId] INT IDENTITY(1,1)  NOT NULL PRIMARY KEY, 
    [isCollected] BIT NOT NULL, 
    [isCancelled] BIT NOT NULL, 
    [bookingDate] DATETIME NOT NULL, 
    [cId] INT NOT NULL FOREIGN KEY REFERENCES CUSTOMER(CID), 
    [routeId] INT NOT NULL FOREIGN KEY REFERENCES ROUTE(ROUTEID), 
    [sId] INT NOT NULL FOREIGN KEY REFERENCES SUBSCRIPTION(SID)
)
